using System;
using System.Data;
using System.Collections.Generic;
namespace eTMS.DAO
{
    /********************************BEGIN CanBoLopDAO****************************************/
    ///<summary>
    /// <para>Author: Auto generated class by CSharp Code Generator v2.0</para>
    /// <para>Date:14/09/2010 34:02:42</para>
    /// <para>Class Name: CanBoLopDAO</para>
    /// <para>Description: Class access to table CanBoLop in database. Class for coder code here</para>
    ///</summary>


    public partial class CanBoLopDAO
    {
        public DataSet SelectAllDSWithSinhVien(int Lop_ID)
        {
            IDbCommand cmd = this.CreateCommand();
            cmd.CommandText = @"SELECT   SinhVien.MaSinhVien, SinhVien.TenSinhVien, SinhVien.DiaChi, SinhVien.Email, SinhVien.SoCMND, SinhVien.DienThoai, SinhVien.GhiChu, SinhVien.GioiTinh, 
                                    SinhVien.NgaySinh, CanBoLop.LopSinhVien_ID, CanBoLop.Lop_ID, CanBoLop.SinhVien_ID, CanBoLop.ChucVuCanBoLop_ID, CanBoLop.CanBoLop_ID
                                FROM            CanBoLop INNER JOIN
                                    SinhVien ON CanBoLop.SinhVien_ID = SinhVien.SinhVien_ID 
                                WHERE CanBoLop.Lop_ID=" + Lop_ID;
            return this.SelectDS(cmd);
        }

    }
    /*****************************************************************************************************/
    /**********************************END CanBoLopDAO*****************************************/
    /*****************************************************************************************************/
}

